<!--
  This file is a part of the open-eBackup project.
  This Source Code Form is subject to the terms of the Mozilla Public License, v. 2.0.
  If a copy of the MPL was not distributed with this file, You can obtain one at
  http://mozilla.org/MPL/2.0/.
  
  Copyright (c) [2024] Huawei Technologies Co.,Ltd.
  
  THIS SOFTWARE IS PROVIDED ON AN "AS IS" BASIS, WITHOUT WARRANTIES OF ANY KIND,
  EITHER EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO NON-INFRINGEMENT,
  MERCHANTABILITY OR FIT FOR A PARTICULAR PURPOSE.
  -->

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html lang="en-us" xml:lang="en-us">
 <head>
  <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
  <meta http-equiv="X-UA-Compatible" content="IE=edge">
  <meta name="DC.Type" content="topic">
  <meta name="DC.Title" content="Checking the PostgreSQL Environment">
  <meta name="product" content="">
  <meta name="DC.Relation" scheme="URI" content="en-us_topic_0000002199970225.html">
  <meta name="prodname" content="">
  <meta name="version" content="">
  <meta name="brand" content="">
  <meta name="DC.Publisher" content="20250306">
  <meta name="prodname" content="csbs">
  <meta name="documenttype" content="usermanual">
  <meta name="DC.Format" content="XHTML">
  <meta name="DC.Identifier" content="EN-US_TOPIC_0000002164603902">
  <meta name="DC.Language" content="en-us">
  <link rel="stylesheet" type="text/css" href="public_sys-resources/commonltr.css">
  <title>Checking the PostgreSQL Environment</title>
 </head>
 <body style="clear:both; padding-left:10px; padding-top:5px; padding-right:5px; padding-bottom:5px">
  <a name="EN-US_TOPIC_0000002164603902"></a><a name="EN-US_TOPIC_0000002164603902"></a>
  <h1 class="topictitle1">Checking the PostgreSQL Environment</h1>
  <div>
   <div class="section">
    <h4 class="sectiontitle">Procedure</h4>
    <ol>
     <li><span>Choose <span class="uicontrol" id="EN-US_TOPIC_0000002164603902__en-us_topic_0000002199964685_uicontrol1389612810362"><b><span id="EN-US_TOPIC_0000002164603902__en-us_topic_0000002199964685_text1089610893610"><strong>Protection</strong></span> &gt; Databases &gt; PostgreSQL</b></span>.</span></li>
     <li><span>View the related information on the <span class="uicontrol"><b>Instance</b></span> tab.</span><p></p>
      <ol type="a">
       <li>This page displays details about PostgreSQL instances.<p><a href="#EN-US_TOPIC_0000002164603902__en-us_topic_0000001296067864_en-us_topic_0000001263775418_table14369422184920">Table 1</a> describes related parameters.</p>
        <div class="note">
         <img src="public_sys-resources/note_3.0-en-us.png"><span class="notetitle"> </span>
         <div class="notebody">
          <p id="EN-US_TOPIC_0000002164603902__en-us_topic_0000002164820458_p4219634163218">Some parameters are not displayed by default. You can click <span><img id="EN-US_TOPIC_0000002164603902__en-us_topic_0000002164820458_image1271105319486" src="en-us_image_0000002200147221.png"></span> next to <strong id="EN-US_TOPIC_0000002164603902__en-us_topic_0000002164820458_b9551254456">Operation</strong> and select a parameter to display it on the current page.</p>
         </div>
        </div>
        <div class="p">
         <div class="tablenoborder">
          <a name="EN-US_TOPIC_0000002164603902__en-us_topic_0000001296067864_en-us_topic_0000001263775418_table14369422184920"></a><a name="en-us_topic_0000001296067864_en-us_topic_0000001263775418_table14369422184920"></a>
          <table cellpadding="4" cellspacing="0" summary="" id="EN-US_TOPIC_0000002164603902__en-us_topic_0000001296067864_en-us_topic_0000001263775418_table14369422184920" frame="border" border="1" rules="all">
           <caption>
            <b>Table 1 </b>PostgreSQL instance information
           </caption>
           <colgroup>
            <col style="width:20.31%">
            <col style="width:79.69000000000001%">
           </colgroup>
           <thead align="left">
            <tr>
             <th align="left" class="cellrowborder" valign="top" width="20.31%" id="mcps1.3.1.2.2.2.1.1.3.1.2.3.1.1"><p>Parameter</p></th>
             <th align="left" class="cellrowborder" valign="top" width="79.69000000000001%" id="mcps1.3.1.2.2.2.1.1.3.1.2.3.1.2"><p>Description</p></th>
            </tr>
           </thead>
           <tbody>
            <tr>
             <td class="cellrowborder" valign="top" width="20.31%" headers="mcps1.3.1.2.2.2.1.1.3.1.2.3.1.1 "><p><strong id="EN-US_TOPIC_0000002164603902__en-us_topic_0000002164820458_b2729746822433">Name</strong></p></td>
             <td class="cellrowborder" valign="top" width="79.69000000000001%" headers="mcps1.3.1.2.2.2.1.1.3.1.2.3.1.2 "><p>Database instance name.</p></td>
            </tr>
            <tr>
             <td class="cellrowborder" valign="top" width="20.31%" headers="mcps1.3.1.2.2.2.1.1.3.1.2.3.1.1 "><p><strong>Status</strong></p></td>
             <td class="cellrowborder" valign="top" width="79.69000000000001%" headers="mcps1.3.1.2.2.2.1.1.3.1.2.3.1.2 "><p>Status of the PostgreSQL cluster.</p>
              <ul>
               <li><span><strong>Online</strong></span>: If the connections between the host where the client is installed and all nodes in the PostgreSQL cluster are normal, <span class="uicontrol"><b><span><strong>Status</strong></span></b></span> is <span class="uicontrol"><b><span><strong>Online</strong></span></b></span>.</li>
               <li><span><strong>Offline</strong></span>: If the connections between the host where the client is installed and all nodes in the PostgreSQL cluster are abnormal, <span class="uicontrol"><b><span><strong>Status</strong></span></b></span> is <span class="uicontrol"><b><span><strong>Offline</strong></span></b></span>.</li>
              </ul></td>
            </tr>
            <tr>
             <td class="cellrowborder" valign="top" width="20.31%" headers="mcps1.3.1.2.2.2.1.1.3.1.2.3.1.1 "><p><strong>IP Address</strong></p></td>
             <td class="cellrowborder" valign="top" width="79.69000000000001%" headers="mcps1.3.1.2.2.2.1.1.3.1.2.3.1.2 "><p>IP address or domain name of a database instance.</p></td>
            </tr>
            <tr>
             <td class="cellrowborder" valign="top" width="20.31%" headers="mcps1.3.1.2.2.2.1.1.3.1.2.3.1.1 "><p><strong>Owning Host/Cluster</strong></p></td>
             <td class="cellrowborder" valign="top" width="79.69000000000001%" headers="mcps1.3.1.2.2.2.1.1.3.1.2.3.1.2 "><p>Name of the host or cluster where a database resides.</p></td>
            </tr>
            <tr>
             <td class="cellrowborder" valign="top" width="20.31%" headers="mcps1.3.1.2.2.2.1.1.3.1.2.3.1.1 "><p><strong>Version</strong></p></td>
             <td class="cellrowborder" valign="top" width="79.69000000000001%" headers="mcps1.3.1.2.2.2.1.1.3.1.2.3.1.2 "><p>Database version.</p></td>
            </tr>
            <tr>
             <td class="cellrowborder" valign="top" width="20.31%" headers="mcps1.3.1.2.2.2.1.1.3.1.2.3.1.1 "><p><strong id="EN-US_TOPIC_0000002164603902__en-us_topic_0000002164820458_b925671019379">SLAs</strong></p></td>
             <td class="cellrowborder" valign="top" width="79.69000000000001%" headers="mcps1.3.1.2.2.2.1.1.3.1.2.3.1.2 "><p>If an SLA is associated with the database, the SLA name is displayed. Otherwise, <span class="uicontrol"><b>--</b></span> is displayed.</p></td>
            </tr>
            <tr>
             <td class="cellrowborder" valign="top" width="20.31%" headers="mcps1.3.1.2.2.2.1.1.3.1.2.3.1.1 "><p><strong id="EN-US_TOPIC_0000002164603902__en-us_topic_0000002164820458_b2087113375371">SLA Compliance</strong></p></td>
             <td class="cellrowborder" valign="top" width="79.69000000000001%" headers="mcps1.3.1.2.2.2.1.1.3.1.2.3.1.2 ">
              <div class="p">
               Whether a backup job is successfully executed based on the backup interval or backup window set in the SLA.
               <ul id="EN-US_TOPIC_0000002164603902__en-us_topic_0000002164820458_en-us_topic_0000002164820450_ul1823814519293">
                <li id="EN-US_TOPIC_0000002164603902__en-us_topic_0000002164820458_en-us_topic_0000002164820450_li9238184572919"><strong id="EN-US_TOPIC_0000002164603902__en-us_topic_0000002164820458_en-us_topic_0000002164820450_b1092516394564">Met</strong>: If the backup time of a backup job (except for the first full backup) meets the backup time window or backup interval requirements and the backup job is executed successfully, SLA compliance is met.</li>
                <li id="EN-US_TOPIC_0000002164603902__en-us_topic_0000002164820458_en-us_topic_0000002164820450_li189142052112912"><strong id="EN-US_TOPIC_0000002164603902__en-us_topic_0000002164820458_en-us_topic_0000002164820450_b541520442564">Missed</strong>: If the backup time does not meet the backup time window or backup interval requirements, for example, if the backup interval set in the SLA for a backup job is once every half an hour but the backup time exceeds half an hour, SLA compliance is missed. In this case, you are advised to adjust the backup interval or backup window.</li>
               </ul>
              </div></td>
            </tr>
            <tr>
             <td class="cellrowborder" valign="top" width="20.31%" headers="mcps1.3.1.2.2.2.1.1.3.1.2.3.1.1 "><p><strong id="EN-US_TOPIC_0000002164603902__en-us_topic_0000002164820458_b5758164315376">Protection Status</strong></p></td>
             <td class="cellrowborder" valign="top" width="79.69000000000001%" headers="mcps1.3.1.2.2.2.1.1.3.1.2.3.1.2 "><p>Whether a database is protected.</p>
              <ul>
               <li><span><strong>Unprotected</strong></span>: The database is not associated with an SLA, or the database is associated with an SLA but protection is disabled.</li>
               <li><span><strong>Protected</strong></span>: The database is associated with an SLA and protection is activated.</li>
               <li><span><strong>Creating</strong></span>: The database is associated with an SLA and protection is being created.</li>
              </ul></td>
            </tr>
            <tr>
             <td class="cellrowborder" valign="top" width="20.31%" headers="mcps1.3.1.2.2.2.1.1.3.1.2.3.1.1 ">
              <div class="p">
               <strong id="EN-US_TOPIC_0000002164603902__en-us_topic_0000002164820458_b827118125517">Tag</strong>
               <div class="note" id="EN-US_TOPIC_0000002164603902__en-us_topic_0000002164820458_note1330311543247">
                <span class="notetitle"> NOTE: </span>
                <div class="notebody">
                 <p id="EN-US_TOPIC_0000002164603902__en-us_topic_0000002164820458_p630385412417"><span id="EN-US_TOPIC_0000002164603902__en-us_topic_0000002164820458_ph5374928181810">This parameter is available only in 1.6.0 and later versions.</span></p>
                </div>
               </div>
              </div></td>
             <td class="cellrowborder" valign="top" width="79.69000000000001%" headers="mcps1.3.1.2.2.2.1.1.3.1.2.3.1.2 "><p>If a tag has been added for the resource, the tag name is displayed. Otherwise, <strong id="EN-US_TOPIC_0000002164603902__en-us_topic_0000002164820458_b1959642011219">--</strong> is displayed.</p></td>
            </tr>
           </tbody>
          </table>
         </div>
        </div></li>
      </ol>
      <ol type="a" start="2">
       <li>Click the name and check the overview, copy data, and jobs. 
        <ul>
         <li><strong>Overview</strong><p>Display the SLA information, job execution time, and total number of copies.</p></li>
         <li><strong>Copy Data</strong><p>You can search for copies by year, month, and day.</p> <p>If <span><img src="en-us_image_0000002200004697.png"></span> is displayed below the time, a copy exists at the time.</p></li>
         <li><strong>Jobs</strong><p>Displays running jobs and historical jobs.</p></li>
        </ul></li>
      </ol> <p></p></li>
     <li><span>View the related information on the <span class="uicontrol"><b>Cluster</b></span> tab.</span><p></p>
      <ol type="a">
       <li>This page displays the details about the cluster where the PostgreSQL database resides.<p>If the PostgreSQL cluster has been discovered in the <span>product</span>, information about the cluster and all hosts in the cluster is displayed on the page.</p> <p><a href="#EN-US_TOPIC_0000002164603902__en-us_topic_0000001296067864_en-us_topic_0000001263775418_table14170211115420">Table 2</a> describes related parameters.</p>
        <div class="tablenoborder">
         <a name="EN-US_TOPIC_0000002164603902__en-us_topic_0000001296067864_en-us_topic_0000001263775418_table14170211115420"></a><a name="en-us_topic_0000001296067864_en-us_topic_0000001263775418_table14170211115420"></a>
         <table cellpadding="4" cellspacing="0" summary="" id="EN-US_TOPIC_0000002164603902__en-us_topic_0000001296067864_en-us_topic_0000001263775418_table14170211115420" frame="border" border="1" rules="all">
          <caption>
           <b>Table 2 </b>Information about the cluster where the PostgreSQL database resides
          </caption>
          <colgroup>
           <col style="width:19.189999999999998%">
           <col style="width:80.81%">
          </colgroup>
          <thead align="left">
           <tr>
            <th align="left" class="cellrowborder" valign="top" width="19.189999999999998%" id="mcps1.3.1.2.3.2.1.1.3.2.3.1.1"><p>Parameter</p></th>
            <th align="left" class="cellrowborder" valign="top" width="80.81%" id="mcps1.3.1.2.3.2.1.1.3.2.3.1.2"><p>Description</p></th>
           </tr>
          </thead>
          <tbody>
           <tr>
            <td class="cellrowborder" valign="top" width="19.189999999999998%" headers="mcps1.3.1.2.3.2.1.1.3.2.3.1.1 "><p><strong id="EN-US_TOPIC_0000002164603902__en-us_topic_0000002164820458_b2729746822433_1">Name</strong></p></td>
            <td class="cellrowborder" valign="top" width="80.81%" headers="mcps1.3.1.2.3.2.1.1.3.2.3.1.2 "><p>Name of the cluster where a database resides.</p></td>
           </tr>
           <tr>
            <td class="cellrowborder" valign="top" width="19.189999999999998%" headers="mcps1.3.1.2.3.2.1.1.3.2.3.1.1 "><p><strong>Status</strong></p></td>
            <td class="cellrowborder" valign="top" width="80.81%" headers="mcps1.3.1.2.3.2.1.1.3.2.3.1.2 ">
             <div class="p">
              Cluster status. 
              <ul>
               <li><span><strong>Online</strong></span>: If the host is powered on and the client installed on the host is running properly, <span class="uicontrol"><b><span><strong>Status</strong></span></b></span> is <span class="uicontrol"><b><span><strong>Online</strong></span></b></span> for the host.<p>If there are online hosts in the cluster, the cluster status is <span class="uicontrol"><b><span><strong>Online</strong></span></b></span>.</p></li>
               <li><span><strong>Offline</strong></span>: If the host is shut down or the client installed on the host is faulty, <span class="uicontrol"><b><span><strong>Status</strong></span></b></span> is <span class="uicontrol"><b><span><strong>Offline</strong></span></b></span> for the host.<p>If all hosts in the cluster are offline, the cluster status is <span class="uicontrol"><b><span><strong>Offline</strong></span></b></span>.</p></li>
              </ul>
             </div></td>
           </tr>
           <tr>
            <td class="cellrowborder" valign="top" width="19.189999999999998%" headers="mcps1.3.1.2.3.2.1.1.3.2.3.1.1 "><p><strong>Cluster Type</strong></p></td>
            <td class="cellrowborder" valign="top" width="80.81%" headers="mcps1.3.1.2.3.2.1.1.3.2.3.1.2 "><p>Type of the cluster.</p></td>
           </tr>
           <tr>
            <td class="cellrowborder" valign="top" width="19.189999999999998%" headers="mcps1.3.1.2.3.2.1.1.3.2.3.1.1 "><p><strong>Type</strong></p></td>
            <td class="cellrowborder" valign="top" width="80.81%" headers="mcps1.3.1.2.3.2.1.1.3.2.3.1.2 "><p>Cluster type. <strong>Active/Standby Replication</strong>: Information of the standby node in the cluster is synchronized from the active node. The information is consistent between the active and standby nodes.</p></td>
           </tr>
           <tr>
            <td class="cellrowborder" valign="top" width="19.189999999999998%" headers="mcps1.3.1.2.3.2.1.1.3.2.3.1.1 "><p><strong>Virtual IP Address</strong></p></td>
            <td class="cellrowborder" valign="top" width="80.81%" headers="mcps1.3.1.2.3.2.1.1.3.2.3.1.2 "><p>Virtual IP address of a database cluster.</p></td>
           </tr>
           <tr>
            <td class="cellrowborder" valign="top" width="19.189999999999998%" headers="mcps1.3.1.2.3.2.1.1.3.2.3.1.1 ">
             <div class="p">
              <strong id="EN-US_TOPIC_0000002164603902__en-us_topic_0000002164820458_b827118125517_1">Tag</strong>
              <div class="note" id="EN-US_TOPIC_0000002164603902__en-us_topic_0000002164820458_note1330311543247_1">
               <span class="notetitle"> NOTE: </span>
               <div class="notebody">
                <p id="EN-US_TOPIC_0000002164603902__en-us_topic_0000002164820458_p630385412417_1"><span id="EN-US_TOPIC_0000002164603902__en-us_topic_0000002164820458_ph5374928181810_1">This parameter is available only in 1.6.0 and later versions.</span></p>
               </div>
              </div>
             </div></td>
            <td class="cellrowborder" valign="top" width="80.81%" headers="mcps1.3.1.2.3.2.1.1.3.2.3.1.2 "><p>If a tag has been added for the resource, the tag name is displayed. Otherwise, <strong id="EN-US_TOPIC_0000002164603902__en-us_topic_0000002164820458_b1959642011219_1">--</strong> is displayed.</p></td>
           </tr>
          </tbody>
         </table>
        </div></li>
       <li>Click a cluster name to view details about hosts and nodes in the cluster.</li>
      </ol> <p></p></li>
    </ol>
   </div>
  </div>
  <div>
   <div class="familylinks">
    <div class="parentlink">
     <strong>Parent topic:</strong> <a href="en-us_topic_0000002199970225.html">PostgreSQL Cluster Environment</a>
    </div>
   </div>
  </div>
 </body>
</html>